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 Key CashFlow 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

Create a bill in Key CashFlow

When creating a bill in Key CashFlow, 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 Key CashFlow, and the GL posting date in Key CashFlow 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 Key CashFlow, the GL posting date in Key CashFlow 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 Key CashFlow, and the GL posting date in Key CashFlow will be updated to the start date of the posting periods selected in Oracle NetSuite.