Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DAYENDS not being transfered to G/L

Status
Not open for further replies.

dbant2003

Technical User
Sep 2, 2003
97
CA
We are experiencing dificulties with inventory control not passing adjustment transactions through to the G/L. Our options are set to create G/L transactions by during posting or Day end processing. There are 7 Dayend transactions outstanding that need to be corrected. How do you go about transfering these transactions through to the G/L. I am thinking that maybe we need to change our options to create G/L transactions On Request using create G/L batch icon. Where is this create G/L batch Icon located. There probably is something else that will need to be changed also so could someone let us know the procedure we should use to correct this problem.
 
The version using is 5.2A and the database is SQL Server.
 
Clearing out old AP and AR transactions is pretty easy, but dayend isn't. Exactly which kinds of transactions do you think are missing - IC, OE, or PO? And how do you know they're missing?

Jay Converse
IT Director
Systemlink, Inc.
 
The transactions are IC adjustments. We have searched through our G/L accounts and cannot find those adjustment numbers even though we can print the adjustment posting journal (in IC) and see the accounts being affected by the adjustment.
 
Set ICADEH.STATUS = 2 for those transactions, and re-run day-end.

Jay Converse
IT Director
Systemlink, Inc.
 
My supervisor wanted me to ask one more question about these adjustments. If we change the status to a 2 from the 3 they are currently set at will it result in the adjustments to be duplicated in IC. I don't believe so but she would like a further confirmation that this will work. Thank you for your response and help, it is greatly appreciated.

I have another question for you about the ePOS transactions that are also not coming through to the G/L. When a cash sale transaction is taken a prepayment is also done at invoice time. Well there are a number of prepayments that have not been processed/passed to the G/L. Would have any incite as to what would cause this to happen how to correct this.
 
No, it's just a flag that says "ready to go to GL?", it doesn't duplicate anything.

I'm not familiar with your ePOS problem, none of my ePOS clients have experienced it.

Jay Converse
IT Director
Systemlink, Inc.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top