Missing Transactions in My Account Order History of a SuiteCommerce Advanced Web Store

Issue: Some of the transactions were missing on the transaction history or purchase history on the my-account page of the website. The number of transactions on the Customer record (Lists > Relationships > Customers > Sales tab > Transactions sub tab) and on SuiteCommerce Advanced (SCA) My Account page (My Account > Orders > Order History/Transaction History) are different.

Solution:

This is usually happens when the Multiple Web Sites feature is enabled.

By default, Sales Orders under the SCA My Account page are filtered by web site ID. The website id can be configured on the configuration record.

To display all the transactions on all website in the NetSuite account, the filter site option is set as “all”.

To display the transactions based on the site id we can select the site id and add the required site ids under the array

If we select “all” on the filter option, still some transactions are missing, then choose ‘siteIds’ as filter option and do not add any ids on the array.

This filter can be found on SSP libraries. To display all transactions generated from different web sites, simply remove this filter by customization

Here are the steps:

1. On custom SspLibraries@2.1.1 module, open the SuiteScript folder and edit the Application.js file using preferred text editor.
2. Find this IF statement below:

 
if (context.getFeature('MULTISITE') && site_id && filter_site && 'all' !== filter_site) 
{
    search_filter_array = filter_site instanceof Array ? filter_site : [];
    search_filter_array.push(site_id, '@NONE@');
}