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 Bill.com℠ 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 Bill.com

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