Month's Sales

[kongming1]

1. Using AccPac 5.3, where can I print out each Month's sales volume report or view this amount for the preparation for GST/PST return?

2. A/P batch finished and posted, but the batch is carelessly deleted in G/L module without posting to G/L, this means that A/P subledger is updated but G/L A/P control account has not been updated. How can I fixed this problem???

Thanks.

 

[jayconverse]

1. You'll have to write a Crystal Report.
2. Restore from backup, or recreat the batch manually from the AP Posting Journal.

Jay Converse
IT Director
Systemlink, Inc.

 

[ettienne]

On point 2, if you know the posting seq no you can edit the AP posting journal header table (forgot which table excactly because it is a new table) and reset the GL create status to zero, then run Create GL batches in AP. One of my clients did the same and this is how I recovered the batch. Oh yes, you need to change one more table where it stores the last posting seq no for GL batches created, this will be in on of the APP0* tables.

 

[kongming1]

Thanks for your message. I am still confusion for these two problems.

1. For the month's sales volume, if I just want to view the volume, no print out, how can I achieve it? since in the Account the sales is cumulative and what I need is to find the separate sales volume for each month.

2. For the second problem, in case of no backup, could you explain in a little detail how to follow the steps ? Could you briefly give me step by step instructions?

Thank you very much.

 

[jayconverse]

1. Change AP Setup/Options/Integration to "on request"
2. Edit APP04, and change the CNTLAS* values to 1
3. Edit APPJS, and change SWPOSTGL to 0 for the posting sequence that got deleted.
4. Edit APPJH, and change GLBATCH to 000000, and GLENTRY to 00000 for the deleted posting sequence
5. Run AP Periodic Processing/Create GL batch.
6. Change AP Setup back again


Jay Converse
IT Director
Systemlink, Inc.

 

[ettienne]

For point 1 go to OE Statistics and Inquiries, Sales Statistics - assuming your are using OE.