Blank Journal Entries are Released to General Ledger

Issue

When the Accounts Payables (AP) module is released to General Ledger (GL), a batch

When the client is releasing to GL from AP, they are experiencing a batch that has an empty total number with no transaction details.

Build Info
———–
Sage Pro 7.5 Build 3500.00 Service Pack 1 (Per JDYS: Same in 7.6.  OK in 7.4)

Steps to Recreate
—————–
1.  Go into company 99 GL
2.  Go into File -> Change Setup Information
3.  Make sure “Allow detail posting from: Accounts Payable” is checked.
4.  Go into AP
5.  Go into Print -> Checks
6.  For the Payment Priority, make sure “Prepayment” has been selected.
7.  Click Proceed
8.  For the Vendor, select ABC1
9.  Enter the following. For the remaining fields enter as desired:
Debit No: 123A
Pay Amount: 500.00
10. Click Save
11. It will prompt “Print an alignment test?”, click No
12. Click Save
13. It will prompt “Save transaction and print this check?” Click Yes.
14. It will prompt “Do you want to reprint prepayment checks?” Click Yes
15. It will prompt “Print an alignment test?” Click No
16. It will prompt “It will prompt” Click Yes
17. It will prompt “Do you want to reprint prepayment checks?” Click No
18. It will prompt “Vendor check comment has been printed. Do you want to clear vendor check comments?” Click No.
19. Click Cancel to return to the main menu.
20. Go into Transaction -> Enter Payables
21. Enter in the following information:
Vendor: ABC1
Amount: 500.00
Invoice No: 123B
22. Click Proceed
23. Leave the Control and the Distribution account as default.
24. Save this invoice and exit.
25. Go into Transaction -> Release to General Ledger
26. It will prompt “Do you want to print a Posting Register?”, Click no
27. It will prompt “Ready to release entries as a detail posting to the General Ledger?” Click Proceed
28. If you go into GL and post, you will see that everything is good (no empty batches and no empty details)
29. Go back into AP
30. Go to Transaction -> Apply Debits
31. Enter the following into the screen:
Vendor: ABC1
Debit No: 123A
32. Click Apply
33. Select invoice Number 123B and click Automatic
34. Click Exit and Release to GL again
35. Go into GL and try to Post the batch. It should prompt the following: “No transactions details exist for Batch #000242 This Batch #000242 will not be posted.” This is not correct and it should not have happened.

Solution or Workaround

This has been reported in PTR 89752 and will/has been addressed in Sage Pro 7.6. Currently there is a patch available for Sage Pro 7.5. Please contact Sage Pro Customer Support to obtain this patch.

The current workaround is to create another journal entry for the blank batch. Database edits are required to delete the record for the batch that cannot be posted.

 

Leave A Comment?