Aliasing product type for import into QuickBooks

Started by lcogan, November 02, 2020, 08:03:11 AM

Previous topic - Next topic

lcogan

Hi David,

We are simplifying our QuickBooks postings. We have  values that we refer to as Billing Units for each product. Instead of posting individual SKU's to QuickBooks, we have started posting billing unit totals, and I'm hoping we can set up SuperManager to work this way for us.

Is it possible for me to  these Billing Unit values to the products, and then import orders as a conglomeration of Billing Unit counts instead of a conglomeration of SKU counts?

David Johns

Lori,

Could you please give me an example of what would be included in a group of orders and how it would translate to what you want in QuickBooks?

Thanks!
David
SuperManager Support
info@thesupermanager.com

lcogan

Hi David,

Here is a small sample of SKUS and their  Billing Units. Instead of importing sales receipts with SKU's on them, we want to be able to import the billing unit and count.

Item   Billing Unit
A1236   C  1x10
A1250   C  1x10 RED
AC2911BDG-B1x36   C  1x36
AC3439XSG-B1x36   C  1x36 RED
AC5979BDG-B2x10   C  2x10
AC1250XSG-B2x10   C  2x10 RED
AC6821BDG-B2x6   C  2x6
A4183XSG-B4x2   C  4x2 RED
ACQ4998XSB-B8x2   C  8x2 RED
ACQ4185OCB-B1x10   C  SQ 1x10
ACQ5194XSG-B1x10   C  SQ 1x10 RED
ACQ5025OCB-B2x6   C  SQ 2x6
ACQ4954OCB-B3x4   C  SQ 3x4
ACQ4626XSB-B3x4   C  SQ 3x4 RED
B1049   C Box 12x1
B0469   C Box 12x1 RED

David Johns

Lori,

I'm not familiar with the "Billing Unit" terminology, but it seems like you could acheive this by making item groups. You would make an item group in QuickBooks with the item name "A1236", for example, which would contain 1 "C 1x10". Please post back if I'm misunderstanding.

Thanks,
David
SuperManager Support
info@thesupermanager.com