Notifications
Announcements
No record found.
Hi ,
May i know where were the transactions kept after the batch status = 'C'.I need to know custid which having a completed batch.
Best Regards
Nani
*This post is locked for comments
Hi,
A 'C' status batch is released but had no effect on GL. The transactions are kept in the same tables as other batches, except nothing in GL.
Since you are talking about AR I can guess this might be a payment applications batch, such as applying an existing Credit Memo to an existing Invoice. You can see the period to post in the Batch Register report. In this particular kind of batch, there is not much to see on reports, except the period closed will be attached to the original documents and the open documents will drop off the Aging.
If you are asking about tables where the transactions are kept, ardoc, artran, aradjust, batch.
Laura
to elaborate just a little on Laura's answer.. for the payment applicaiotn with a status of "C", as she says, this is NOT a batch that adds money to the system, it is taking an already-entered payment and just applying it.
Therefore, there are no ARTRAN records. There are ARADJUST records, and the field you need to look for in ARADJUST is the "ADJGBATNBR" which will be the batch number of the "C" batch. Those records will have CUSTID in them.
Hi Toni and Laura ,
Tq very much and big thanks for the great information.
Actually I'm in Solomon 5.5. I executed the Batch Register report.I have check the period post was 082007.
It was already having completed batch for past year.As sudden for this year and last year the batch will be updated to 'S' status without knowing.
As a IT person i can always update the status from 'S' to 'C'. I just wonder why it happen.
I try to fine the custid with that particular batch but i could not fine any custid attached with that batch.
i can only see the record of that batch in the batch table with value 1 in rlsed field.
Toni , i don't have the ADJGBATNBR field in my aradjust table.
OOps! sorry, it's ADJBATNBR.
The only scenario that I can think of is that someone was trying to change a batch's status, say, from "S" to "B" using SQL. Maybe the batch was in another module. They forgot to specify the module, and changed the old AR batch to "B" as well. Then they tried to RE-release that old AR batch, and it got suspended.
Toni (Sherlock mode)
Oh! And there would not be a CUSTID in the batch because there can be more than one customer in a batch. The CUSTID would be at the ARDOC level (as well as ARTRAN and ARADJUST)
Hi Toni ,
I'm only one person can update the record in SQL.I always updating the batch from 'S' to 'C'.
i have the adjbatnbr field in my aradjust table.
Select * from aradjust
where adjbatnbr = 'XXXX'
Return no records found for that particular batch .
Any clues ....
This is getting messy. Are you keeping a list of which batches you updated?
A suspended batch won't have aradjust records. If it is a $0 payment application batch, as Toni mentioned, it won't have artran records either.
If the Batch.Status is the only field you updated, you could look in Batch for records where status = 'c' and rlsed = 0 (released = false). This will give you a list of formerly suspended batches. Therefore, you could use that list of batch numbers to join over to ardoc to try and see what customers were related to these batches.
AR Integrity Check might be a good idea.
ok-- if the original batch was empty, it's possible that someone tried to release it and it got an "S" because it was empty. When this happens, I often tell the client to just re-use the batch with new transactions, rather than the dangerous practice of using SQL.
Newer versions are getting somewhat better at handling zero batches, but some screens will attempt to release an empty batch, and get to "S" status. then you cannot delete it or anything.
Tq toni and Laura.
There is only one batch having that problem.emm i always keep the batch number for updating in sql and always do the backup listing before updating.
may i know the sequence of the batch status for normal process.
From Unposted - Posted OR Unposted - Completed -Posted.
OR it depends on transactions in that batches ?
All batches start out with status H = Hold.
When you release it, it becomes either Unposted or Posted, depending on the period of GL, whether or not Automatic Posting is turned on in GL, your Access Rights, etc.
An Unposted batch can be Posted in GL Post Transactions screen.
If a batch has no GL impact ($0 debit and $0 credit), then it becomes status C = Completed.
If there is a problem releasing it, it becomes status S = Suspended/Partially Released and it creates an Event Log with an error.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
