Sage 50 Mappings

Sage 50 Mappings

We get asked regularly how to handle Sage 50 departments. They get used in so many different ways that there is no right or wrong answer but hopefully this help article will add some context for you. 

Sage Projects

Do you use Sage Projects & Cost Codes ? If you answer yes, then skip to Option 3 – If no then you have some options here so carry on reading. 

Option 1 - Cost Codes

Cost codes are a great choice for Sage departments. They are completely arbitrary and are a line-level option. A cost code is easy to set up, and you can rename the label to match your requirements. The only thing to take into consideration is that there is no delivery address with a cost code. 
 
Zahaar Screen Shot
 
If you use the SmartSync tool, you will be able to map the cost codes to Sage Departments. If you choose to export to a flat file, choose the Sage 50 CSV and edit your mappings file in Sage to point the department at the cost code 
Line item level: Yes  | Has Delivery Address: No 

Option 2 - Projects 

Projects in Zahara are designed for the ring-fencing of spend – as the name suggests. A job, an event, a construction project. The refurbishment of a room. Here you can set a budget and visualise spend against a target. You can use this line item value as a department as well if you choose. Many people do use Sage 50 departments as projects/jobs so using this in Zahara makes good sense. Rather than one static analysis code though, we’d recommend you populate the project fields and get great value out of the feature. 
 
Zahara Screen Shot
 
Projects are line item level and have a delivery address. 
Line item level: Yes  | Has Delivery Address: Yes 

Option 3 - Divisions 

So you use Sage Projects and therefore costs codes. This means you now have a limited option on the Sage departments. The only spare value left to map to is the Zahara division. The division has a field called the Division ID – Populate this with the Sage department ID – ie 101. 
 
Zahara Screen Shot
 
Usually, a Division is an “above the line item” value but you can have a separate division per line item as well on both invoices and purchase orders. 
If you opt to use our SmartSync tool, this value is made available and in the settings of SmartSync, you have the option to set the department of Sage to the division of Zahara. 
The divisions are used primarily for workflows/approvals and in our world are the natural groupings of people in the organisation – ie the sales team. A division can have a budget as well. 
 
Zahara Screen Shot
 
Line item level: Yes  | Has Delivery Address: Yes 

Summary

So you have some choices here on how you handle the Sage 50 Department. It’s really down to the overall structure and what will be compromised by the choice you make – if anything. Reading this together with the Business Planning Guide should help you make the right decision. 

    • Related Articles

    • What versions of Sage does Zahara integrate with

      Background  Zahara offers a number of integrations with different Sage products but not all. This is mainly due to Sage buying and then rebranding totally different products with the Sage name. This has caused confusion with regards to what versions ...

    • Smartsync for Sage 200

      Our SmartSync tool for Sage 200 is custom-built for the version of Sage 200 you use. Our process is as follows: We remote onto your Sage server to check the version of Sage 200 you use. We will attempt to connect to Sage using our test tool. To ...

    • Sage 50 Integration

      Sage 50 is integrated with Zahara using our SmartSync on-premise tool that can be installed on a PC or server on your network connecting to both Sage 50 and Zahara. SmartSync will not only sync vendors and coding from Sage, but it will also listen ...

    • SmartSync for Sage 50 pre install

      SmartSync is our own in-house developed tool that can sit between Zahara, Sage and locally installed OCR programs, and can pull the nominal (or GL) codes, tax codes and suppliers through to Zahara and allow the posting of invoices raised and approved ...

    • Sage 50 staging data

      If you are a Sage 50 user, one of the things you may want to do is export your suppliers, nominal codes & tax codes. To do this, and to get the values we need in Zahara, we recommend you follow these simple steps: Suppliers From Sage 50, open ...