Bulk Fulfillment Encounters Error: The transaction date you specified is not within the date range of your accounting period

Scenario

1. Navigate to Setup > Accounting > Accounting Preferences > General tab
2. Set Allow Transaction Date Outside of Posting Period = Disallow
3. Navigate to Transactions > Sales > Fulfill Orders
4. Set:

• Location = Location X
• Date = 10/31/2014
• Set Posting Period = Oct 2014

5. Choose the Sales Order to fulfill
6. Hit Save
7. Actual Result: Item Fulfillments were not created

Error: "The transaction date you specified is not within the date range of your accounting period"

Solution

• If user had set Allow Transaction Date Outside of Posting Period = Allow then NetSuite will allow us to create the Item Fulfillment from the Bulk Fulfillment page
• The created Item Fulfillment will show posting period = Oct 2014 and current date( example 11/3/2014) and in the following fields:
• Transaction Date
• Picked Date
• Packed Date
• Shipped Date
• This is because Setup> Accounting > Accounting Preferences > Order Management tab > Update Transaction Date Upon Fulfillment Status Change = True
• As per the field help level of Picked Date / Packed Date / Shipped Date:

If Picked Date / Packed Date / Shipped Date field is empty then the value of the field and the Transaction Date field are populated with the Current Date

• There is a conflict between the Bulk Fulfillment and the Item Fulfillment form
• There is only one date field in the Bulk Fulfillment page and this is for the Transaction Date
• Since there are no Picked Date /Packed Date / Shipped Date in the Bulk Fulfillment date then NetSuite will assume that the Picked Date / Packed Date / Shipped Date value is null
• This will then set the current date as the default value for Picked Date /Packed Date / Shipped Date and Transaction Date.
• Request to have Picked Date /Packed Date / Shipped Date in the Fulfill Orders window is currently an Enhancement (315405)
• In order to get the correct dates in the Item Fulfillments and not get the“the transaction date you specified is not within the date range of your accounting period” error, user will either have to:
• Disable the preference: Update Transaction Date Upon Fulfillment Status Change or
• Set Allow Transaction Date Outside of Posting Period = Warn/Allowor
• Manually enter the Item Fulfillments from the Sales Orders one by one