Back to website
Login
Home
Login
Register
Back to website
There was a problem loading the comments.
SQL Location of GL Accounts for Categories
Support Portal
»
Knowledgebase
» Viewing Article
Print
11/16/2012 8:11 AM
General
SQL Database
The GL Accounts for Categories are stored in the Switches table:
SWI_Type = 'O'
SWI_ID = CAT_ID
SWI_Switch = 1
SWI_SW1 = 0
SWI_SW2 = GL Accounts in 3 20 character chunks
Share via
Related Articles
Stock Location - Report On Just One Location
Magento: Re-Arrange Inventory Categories
Handling "Unassigned" Categories
Categories
26
General
79
Inventory
26
Accounts Receivable
5
Accounts Payable
10
General Ledger
14
Networking
11
Multi-Store for PFW
10
Vendors
6
Upgrades
3
Commissions
7
Taxes
19
Purchase Orders
4
Credit Card Processing
49
Invoices & Invoicing
16
Errors
22
Printers & Printing
21
Reports
1
Help File
22
Customers
6
Labels
15
Layaways
19
Orders
14
Service Orders
3
Backups
6
Setup PFW (Legacy)
3
Tools
4
Quotes
5
Internet Orders
5
Checks
11
Troubleshooting
2
Employees
1
Consignments
1
Service Appointments
3
Backups
4
Stations
1
Customer Management
56
Fixes
6
New Features
21
POSitive Commerce 1.0 - Joomla
13
Setup POSitive (General)
6
Multi-Site for POSitive
14
SQL Database
1
POSitive Commerce 2.5 - Joomla
1
POSitive Commerce 1.5 - Joomla
1
Accounting
15
POSitive Commerce - Magento
1
v6
1
--- FAQ ---
© POSitive Software Company
English