AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Import checkmark payroll to myob4/2/2023 The selling price of 1 unit, up to 11 characters, numeric, including 4 decimal places The minimum quantity you want to keep in stock, numeric, no character limit, but a limit of up to 6 decimal places The number of items to purchase when reordering it, numeric, no character limit, but a limit of up to 6 decimal places If the item is inventoried (the Inventory field is set to 'I'), this field must have a value. The unit of measure you buy the item in, such as box or can, up to 5 characters, alphanumeric Unit of measure (in the Buying section of an item) Must match a pre-existing Tax code in the Tax Code List. The default tax to use when buying the item, 3 characters, alphanumeric. Tax code (in the Buying section of an item) The supplier’s number for the item or SKU (Stock Keeping Unit), up to 30 characters, alphanumeric. (If the supplier is an individual, matches the name in this format: Lastname, Firstname.) Must match the name of a supplier contact in MYOB Business. The name of the primary supplier of the item, alphanumeric. Use item description on sales and purchasesĭisplay the description of your item on invoices, 1 character, Y for yes, N for no The description of your item, up to 255 characters, alphanumeric. May have an optional non‑numeric separator between the first digit and the last 4 digits, for example: 5‑1100. Must be a valid, pre-existing account number (you can't add a new account as part of the import), 5 characters, numeric, using the exact account number as it appears on the Accounts page in MYOB Business. The linked expense or cost of sales account you use for tracking purchases of an item. May have an optional non‑numeric separator between the first digit and the last 4 digits, for example: 4‑1600. The linked income account you use for tracking sales of this item. Must be a valid, pre-existing account number (you can't add a new account as part of the import), 5 characters, numeric, using the exact account number as it appears on the Accounts page in MYOB Business. May have an optional non‑numeric separator between the first digit and the last 4 digits, for example: 1‑1140. The linked asset account you use for tracking the value of the stock on hand of this item. Must be a valid, pre-existing account number (you can't add a new account as part of the import), 5 characters, numeric, using the exact account number as it appears on the Accounts page in MYOB Business. Indicates that you inventory the item, 1 character, I for yes or blank for no Indicates whether you sell the item, 1 character, S for yes or blank for no Indicates whether you buy the item, 1 character, B for yes or blank for no (Recommended but not mandatory) The name of the item, up to 30 characters, alphanumeric Using an existing item can lead to reject duplicate or replace the an existing item. A unique identifier for the item, up to 30 characters, alphanumeric. If you like, you can give the file a meaningful name, such as "Item Import" or similar.Ī mandatory field for all items. When you're done, save the template as a text (.TXT) file.
0 Comments
Read More
Leave a Reply. |