当你的供应商或顾客是一间大机构，他们要求你以他们的货品编号和货品名称来进行交易，是很普遍的现象。例如你向可口可乐公司采购或销售给AEON,他们可能就会要求你以他们的货品编号交易，以减轻在他们输入系统时需要更改或转换货品编号的负担。让我们看看SQL会计软件里的供应商与顾客货品编号如何帮助你。

When your supplier or customer is a big organisation, it is normal that they will request you to transact with them according to their Item Code or Item Description instead of using your own. Example, if you send purchase order to Coca-Cola manufacturer, or sell Coca-Cola to AEON, they may request you transact using their item code to ease their burden without need to translate/convert your item code during entry into their system. So, let see how SQL Accounting System Customer/Supplier Item Code work for you.

First, we need to set the Customer Item Code, Customer Item Description, Supplier Item Code, Supplier Item Description in Stock Maintain Stock Item for a particular item.

I maintain an Item call Blue Pen. When dealing with two of my customers, A Home Furnishing & Service and Wawasan Sdn Bhd, they want me to show their item code and item description in my Invoice, so the setting is as follow.

When dealing with two of my Suppliers, Empire Trading and Wawasan Sdn Bhd and New Lighting House, they want me to show their item code and item description in my Purchase Order, so the setting is as follow.

After setting, let’s go to Purchase Order. Normally, when create Purchase Order, we will select an item base on our own Item Code or Item Description. But in this case, you can select Supplier Item Code.

We are able to customise a Purchase Order Template that show Supplier Item Code and Supplier Item Description according to the Supplier selected.

The same theory applies to sales side. When we create an Invoice, we can select Customer Item Code.

We also able to customise an Invoice Template that show Customer Item Code and Customer Item Description according to the Customer selected.

Please refer below for the Tutorial video: