Automate the Creation of 3M POS Platform Template

Using MYOB AccountRight or MYOB Classic (Premier or V19) you are able to automate the creation of the 3M POS Platform Template using the Business Intelligence solution Bi4Cloud. Bi4Cloud is a Certified MYOB Add-on solution which will also provide you with a very flexible sales reporting tool to help in your business.

Create the 3M POS Report Directly from your MYOB data

Most of the required fields can be collected directly from Item sales transactions in MYOB.

Some fields will require you to setup your MYOB file to be able to automate the reporting.

Setup your MYOB file to collect Key data

Field 1 - Channel Partner ID

Enter into the Card ID field on the Supplier Card

Field 2 - Sales Org & Fields 4 & 5 Period Start & End dates

Sales Org (country) - enter into the Supplier Card as a Custom Field
Period Start Date and Period End Date - enter into the Supplier Card as Custom Fields
Note: The Start & End date should be entered into the Supplier Card field each month in the format YYYYMMDD e.g. 1 May 18 is 20180501

Field 15 - Material Short ID

Enter as the Item Number on the Item card

Field 16 - Material UPC 

Enter as Supplier Item Number on the Buying Details tab of the Supplier card.

Enter 3M as the Primary Supplier for Reorders, this will help to later filter to report on all 3M products sold.

Field 17 - Material ID or SKU & Field 22 - Unit of Measure UOM

Product Code - enter on the Item Details tab of the Item Card.

UOM - enter as a 3 character e.g. BOX, EA on the Item Details tab of the Item Card