ISTech Support Forum

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

Message started by cbsi204 on 02/25/08 at 11:59:34

Title: Sales and Posting date
Post by cbsi204 on 02/25/08 at 11:59:34

I have just recently had a problem when posting sales. I check to use today's date but then when it actually posts it has used another date (past or future) and it keeps happening. I don't know what I need to do. I have been using DBA for about 2 years now and I haven't had this issue before. I shipped and invoiced on 02/07/08 and 02/08/08 and once it posted it had dates from 03/07 to 04/08. Now my month end financials are all mixed up from 03/07, 04/07, 10/07, 11/07, 12/07 and 01/08. I also did sales on 02/22 that posted back to 11/07. What do I need to do to fix this and what do I need to do to keep it from happening in the future? I did go in and do GL transactions to reverse the entries for those dates and then did GL transactions for the correct dates but now my A/R is off from my financials as well as my Inventory Value. Please advise.

Thanks,
Dani
danielle@plmfg.com

Title: Re: Sales and Posting date
Post by Dawn on 02/25/08 at 13:13:27

I've only had that happen to me when I actually entered the wrong date thinking I entered the correct date.

First - I would void the invoices. Check to see if it voided on the dates they posted to (I think it will actually ask you what day to void).

Second - Go to AM-A and set the year end the last date of the previous month. Once you set this nothing (other than GL entries) will post to any date prior to that.

Third - Did you reset your AM-B Fiscal Year Routine at the end of 2007? If your year end is not at 12/31/07 check to see what it is set for.

Fourt - Re-invoice. Pay particular attention to when you print the invoices. It gives you the option to print the day it shipped or todays date.

If for some reason it tries to put in 2007 is should give you a warning about printing in a previous year and or posting to a closed date (AM-A).

Title: Re: Sales and Posting date
Post by Lynn_Pantic on 03/14/08 at 14:58:35

When printing and posting invoices, pay attention to the date related questions on the screen. If you don't enter a ship date when releasing the order in SO-E, then say Y to use Existing SO Ship Date when printing the invoice and then Y to use Ship Date as Post date when posting, then whatever (potentially incorrect) date was on the order as estimated ship date could be used for posting.