Welcome, Guest. Please Login.
05/18/25 at 05:45:33
News:
Home Help Search Login


Pages: 1
Send Topic Print
Wrong Invoice date (Read 434 times)
David Waldmann
Active Member
*****


Live to work, or
work to live?

Posts: 1919
Gender: male
Wrong Invoice date
07/03/07 at 11:43:57
 
Over the last week and a half we have noticed a strange phenomenon. Some invoices are printing (and posting, if not caught) with the date 6/20/07. The first time we noticed it, they were supposed to be dated the 22nd, and it seemed reasonable to think that there was a keying error somewhere, although there were several that were also dated the 22nd like they were supposed to be, so it was not universal.
 
Upon further research I have found that this has happened a few times before, where, for two or three weeks random invoices get printed and posted with a previous date. For instance, from 1/10 - 1/26/05 a bunch of invoices posted with the date 1/6/05.
 
The only thing that SEEMS to be in common (but not exclusively) is that they are ones that do not have Packing Lists printed with the ship date on them. Since we do not enter a date in SO-E when releasing (we leave it blank), maybe that is getting messed with somehow.
 
This is our normal flow:
Enter SO, not ready to invoice
Print Pick List, without ship date
Later on, possibly several days:
Release SO, leave ship date blank
Optional --> print Packing List (no packing list for CODs or Credit Card invoices), over-ride existing ship dates* with "today"
Print Invoice
Following day:
Post Invoices
 
One last thing. We almost never close DBA/Evo, so the date displayed on the status bar is often many days/weeks in the past. I thought I had hit upon that as the reason, but I checked, and the date on the workstation that processed this last series of invoices is on 6/19/07 and the date they are being posted for is 6/20/07.
 
The one thing I am quite sure of, since we started checking this a few days ago, is that the original invoice is printing with the wrong date. If we catch it there we're fine. It's not in the posting process.
 
* I've checked several of the invoices from this last batch, and 6/20/07 is not on them anywhere. Not estimated ship date, not customer due date, WO start/complete (if applicable - some do have WOs, some do not). Nothin.
Back to top
 
 

David N Waldmann
President
Vermont Hardwoods
Chester, VT

Evo-ERP, 5 user
IST Build: 3/4/19, patched 04/30/19
Pervasive v11.31
Server 2012 / Win10 x64
Crystal Reports v11
Email WWW   IP Logged
David Waldmann
Active Member
*****


Live to work, or
work to live?

Posts: 1919
Gender: male
Re: Wrong Invoice date
Reply #1 - 07/10/07 at 05:28:29
 
I believe I've figured it out. If so, this is what happened:
 
SOs for the day were released.
Packing Lists were printed, BUT someone forgot to change "Print Non-Released Lines?" to N
EVERY open SO got a PL printed, with "today" as a Ship Date.
This was not a problem for any orders that get a packing list in the future, since the "Ship Date" would be re-set again when the PL was printed. But we don't print PLs for Credit Card, COD or customer pick-up orders, so those are the ones that got the wrong date on the invoice.
 
I never realized that "Ship Date" on that screen is apparently some separate field somewhere. Since it says "Use Existing Ship Dates?" I thought it was using "expected Ship Date" from the SO. Apparently not. The reason I figured out the problem is because I was releasing orders while our normal entry person was on vacation and I saw 6/20/07 as the "Ship Date" in SO-E. Normally they are blank.
 
What places (if any) is "Ship Date" entered other than SO-C or SO-E?
 
Any ideas for resetting the "Ship Date" when this happens again (because it will....), other than going through SO-E for each open SO and deleting it?
Back to top
 
 

David N Waldmann
President
Vermont Hardwoods
Chester, VT

Evo-ERP, 5 user
IST Build: 3/4/19, patched 04/30/19
Pervasive v11.31
Server 2012 / Win10 x64
Crystal Reports v11
Email WWW   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: Wrong Invoice date
Reply #2 - 07/10/07 at 07:50:02
 
The Ship Date is saved to the Sales Order header (BKAR.INV.SHIPDT) and could be cleared out using UT-K-B (once all pending invoices are posted) if it was mistakenly set as in this case.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
David Waldmann
Active Member
*****


Live to work, or
work to live?

Posts: 1919
Gender: male
Re: Wrong Invoice date
Reply #3 - 07/10/07 at 12:08:34
 
OK, thanks. I will save this for future use.
 
edit:
Just tried it in my test company. Works Great!
Back to top
 
 

David N Waldmann
President
Vermont Hardwoods
Chester, VT

Evo-ERP, 5 user
IST Build: 3/4/19, patched 04/30/19
Pervasive v11.31
Server 2012 / Win10 x64
Crystal Reports v11
Email WWW   IP Logged
Pages: 1
Send Topic Print