Affects

Clients attempting to create a BAS posting. 

Error

Warning: There are still postings open that are dated within the BAS date range. Any BAS applicable journals that these postings have created WILL be processed. 

Resolution

This message is purely a warning and you can continue to process the BAS with the postings open however you may wish to close off any postings. 

To stop this warning from appearing the first thing to do it check all areas of the system where there may be an open posting this includes but is not limited to

• Debtors
• Creditors
• General Ledger Journals
• Payroll 

If once you have checked all of these and can not see any postings open please create a Service Desk ticket and we can help to identify the posting/s in question. 

Considerations

Before closing open postings you may need to consider if it is appropriate for them to be closed. As mentioned above you do NOT need to close the postings in order to complete the BAS.

SELECT * FROM finance.GeneralLedgerPostingControl glpc WHERE glpc.PostingDate BETWEEN 'YYY-MM-DD' AND 'YYYY-MM-DD' AND  (  glpc.PostingCompleteFlag = 0  OR glpc.PostingModifiedFlag <> 0 ) AND glpc.PostingDeletedFlag = 0

Begin tran          Update finance.GeneralLedgerPostingControl set PostingCompleteFlag = 1 Where PostingNumber = XXXX              Rollback 
Select * from finance.GeneralLedgerPostingControl where PostingNumber = XXXX