ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Sales >> ship date
http://www.istechforum.com/YaBB.pl?num=1126889759

Message started by HB on 09/16/05 at 08:55:59

Title: ship date
Post by HB on 09/16/05 at 08:55:59

When releasing sales orders for shipping and invoicing, the shipdate in the SO-E screen was at that time updated by our UPS integration link to the actual ship date. We may not invoice the same day or invoice several days of shipments together.
When printing unposted invoices of this mixed batch (print all invoices released and not printed) the shipdate is overwritten by the ship date entered in the invoice print screen.
Question: is there a way to retain the original release shipdate info?

Title: Re: ship date
Post by JNAPIER on 09/16/05 at 09:46:26

Say Y to the first prompt, use printed ship date as Invoice date.

John

Title: Re: ship date
Post by Mike_Habich on 09/16/05 at 09:47:11

Not an answer, but a question...how did you get the UPS link to update the ship date?

Maybe an answer...In SO-F, did you answer Y to "Print Invoice Date same as Ship Date?" This appears to leave the ship date as 00/00/00.

Title: Re: ship date
Post by HB on 09/16/05 at 10:26:57

Problem with that choice is that invoice dates are all over the place. This is (for us) a problem when the shipdate overlaps into the previous month at the beginning of a month. we like to have a clear cut 'month end" figure on our reports.

As for the UPS link;
I have been following the various postings with great interest. My solution is a batch end of day export to a csv file. After UPS picks up, that csv file gets imported and modified by a series of access queries:
1.) I eliminate duplicate references and end up with 1 tracking number in a table for each shipment (UPS allows tracking of multiple packages through one tracking number)
2.) I modify (through a queriy) the date to a format that is accepted by DBA (UPS includes minutes and seconds etc in the date)
I finally do an update query to write the info to the BKARINV database.
(there is a little bit more to it - too much to fit it all in here)
The whole update is automated by using the scheduler from within windows at 9pm (that is why I need the ship date to stay as submitted by UPS - Invoicing takes place the following day with the invoice date of that day)
Anybody interested, write me an email at helmut@generalpencil.com
I am more than willing to share the Access mdb file