Sage 300 consolidated receipts batches are posting to the period end instead of the document/posting date of the batch.

SOLVED

All of sudden Sage 300 consolidated receipts batches are posting to the period end instead of the document/posting date of the batch. All of my March receipts are posting to March 31st regardless of the posting date selected in the batch.

Has anyone else had this happen and does anyone know how to fix this?

Parents
  • 0

    Check your work, this is user error.

  • 0 in reply to Jay Converse Acumen

    I have the original batch and the consolidated batch on screen. The original batch shows a receipt date and posting date of march 14 and the consolidated batch entry shows a document date and posting date of march 31.

    I did a test batch and the consolidated entry shows up with the document date is greyed out with only the posting date open to change. So, not user error.

    It's something that is happening during the creation of the consolidated entry. I've looked at the options in the G/L Integration window located in Accounts Receivable and see nothing that sets the document date on the consolidated entry.

    Are there settings for consolidation entries elsewhere?

  • 0 in reply to Amy Tower

    Consolidated batches are a bad idea, none of my clients do it.  My vote is you stop.

  • 0 in reply to Jay Converse Acumen

    Yeah, I inherited this, unfortunately. I don't like batch systems. I've discovered that the consolidated entry is acting correctly; but, my G/L and bank rec are not. The g/l normally shows everything posted in the month selected and the rec all cash receipts and disbursements at their subledger document date. I had to log into the system as at March 31 for these receipts to show up in the G/L! They still won't show up in my bank rec though even when logged in at March 31...

    Can you turn off batch processing in Sage 300??

Reply
  • 0 in reply to Jay Converse Acumen

    Yeah, I inherited this, unfortunately. I don't like batch systems. I've discovered that the consolidated entry is acting correctly; but, my G/L and bank rec are not. The g/l normally shows everything posted in the month selected and the rec all cash receipts and disbursements at their subledger document date. I had to log into the system as at March 31 for these receipts to show up in the G/L! They still won't show up in my bank rec though even when logged in at March 31...

    Can you turn off batch processing in Sage 300??

Children