ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Sales >> Customer Due Date report
http://www.istechforum.com/YaBB.pl?num=1100281422

Message started by cathyh on 11/12/04 at 09:43:42

Title: Customer Due Date report
Post by cathyh on 11/12/04 at 09:43:42

My sales dept would like to see a report with the customer due date along with the est ship date. I looked in the file for SO Line Items and found the date stored in bkar.invl.asd. I understand from another thread that the report is possible after invoicing in the on-time report, but we would like a listing before invoicing. I was looking for a report to put this field into; the user defined detail report is bksooj1 and there is no corresponding t6 file in my list of reports to edit. Can I edit this bk file with the Tas Editor? Am I on the right track or should I just do this in Access?? :-/

Title: Re: Customer Due Date report
Post by aricon on 11/12/04 at 10:05:05

Cathy,

Lynn is the resident expert in Evo (TAS6), but I believe that you can only play with reports in the T6 editor if they have been compiled for T6. And that one most likely has not been.

Also, the ASD field is Actual Ship Date. Not due date or Estimated date.

Title: Re: Customer Due Date report
Post by cathyh on 11/12/04 at 10:47:32

That's wha I though, Lorne, about both the report editing and the ASD being actual ship date. However, when I went into maintain database, and looked for the field with my customer due date in it, on a Sales order that has not been shipped, it was in the ASD field. In fact in the BKARINVL ( OPEN SALES ORDERS?)file there are two date fields, esd and asd, both have dates in them, even though no lines have been shipped.

Title: Re: Customer Due Date report
Post by aricon on 11/12/04 at 11:35:27

You should probably email Lynn directly as I thought she was using a field in another data file they created for that "desired date".

Title: Re: Customer Due Date report
Post by Cyndee Pappas on 11/12/04 at 13:22:42

See this topic "Requested vs. Estimated Due Dates"
The way I read it, ASD is being used for the dream date until invoiced, then dream date is stored in the SO tracking file (ISARHCHG or whatever). Then the ASD is used for the actual ship date in the SO history files.

Title: Re: Customer Due Date report
Post by aricon on 11/12/04 at 14:27:26

Good job Cyndee. I was pretty sure that ISTS was using that data file somewhere in the process. Not sure I agree with how this was done, as it makes using any external reporting mechanism for this purpose just about impossible. But that is just my issue.... ;)

Title: Re: Customer Due Date report
Post by Lynn Pantic on 11/15/04 at 10:10:31

Cyndee has it right and it was necessary to use an external file since we have committed not to change the underlying structure of the existing files.