Oracle NetSuite: How the sync works with GL posting dates and posting periods

The GL Posting Date is the date that will be used to post the transaction in the General Ledger in Oracle NetSuite. This is the date which determines which period the transaction will be posted into regardless of the Invoice date.

The GL posting date on bills will sync in both directions between Cashflow360℠ and Oracle NetSuite with bundle 3.2 or later.

To use GL Posting Date when syncing with Netsuite, the following settings need to be configured in Netsuite:

  1. Hover over Setup > Accounting > select Accounting Preferences
  2. On Accounting Preferences Edit page, select the General Ledger subtab:
    • ALLOW TRANSACTION DATE OUTSIDE OF POSTING PERIOD - set to Allow
    • DEFAULT POSTING PERIOD WHEN TRANSACTION DATE IN CLOSED PERIOD - set to current period

Also, the following configurations under the accounting preferences in Netsuite need to be the following:

  1. Hover over Setup > Accounting > Accounting Preferences > Order Management.

    • Default vendor bill status needs to be approved
  2. Hover over Setup > Accounting > Accounting Preferences >Approval Routing

    • Approval routing for vendor bills need to be unchecked

Create a bill in Cashflow360

When creating a bill in Cashflow360, the GL posting date is populated with the Invoice date by default and is editable. Once saved the bill will sync to Oracle NetSuite and be mapped to the posting period the GL posting date is in.

If the bill is edited in Oracle NetSuite, changes will sync back to Cashflow360, and the GL posting date in Cashflow360 will be updated to the start date of the posting periods selected in Oracle NetSuite.


Create a bill in Oracle NetSuite

When creating a bill in Oracle NetSuite, the posting period is populated with the current posting period by default and is editable. Once saved the bill will sync to Cashflow360, the GL posting date in Cashflow360 will be populated with the start date of the posting periods selected in Oracle NetSuite.

If the bill is edited in Oracle NetSuite, changes will sync back to Cashflow360, and the GL posting date in Cashflow360 will be updated to the start date of the posting periods selected in Oracle NetSuite.