How to map Invoice Date to Sage 300 when creating a new invoice? (4 replies)
Is this an A/R or an O/E Invoice?
Irrespective, it should work.
What format is your date? Your date needs a valid date also, not the yyyyMMdd format of the database (unless the IMan server is configured for that format).
Thanks
Thank you so much for the reply. So this would be an O/E Invoice. I think you just unlocked it for me though. I was passing through YYYYMMDD! So, what does Sage 300 ERP consider a valid date? DD/MM/YYYY? And I assume there's a conversion function I could do in a map transform to change YYYYMMDD to a valid date? Thank you SO much for this.
Ok, Got it! I was able to handle this by converting the date in SQL as part of my DB read. CONVERT(VARCHAR(50), CONVERT(Datetime, CONVERT(nvarchar, SHIP_DATE)), 101) AS MM_DD_YYYY
Arline, if the format of the date from SQL is yyyyMMdd then you can use the NumberToDate function to convert to a valid date.
I have a job that invoices shipments. I am mapping a specific date to "Invoice Date" and yet it does not appear on the invoice. IMAN does not throw any errors, the job reports success, and I can see in the IMAN Preview screen that the "Invoice Date" value that I mapped LOOKS like it has been created successfully. But when I check the invoice in Sage, the invoice date is set to today's date. Since I can set the Invoice date in the API, I am assuming that I should be able to do this. Your thoughts?
Versions
Assembly Versions:
Product Update: PU4
Config Version: 4.11
DB Version: 4.13