PASTEL INTEGRATION
OVERVIEW
The Pastel Integration tool allows you to upload invoices, credit notes, GRV’s and RTS’s from Sync into Pastel. This tool ensures that once a batch is uploaded, from Sync, into Pastel you cannot upload those items again, hence preventing duplications within Pastel.
The Pastel Integration tool comes in two forms, one for Pastel Evolution (SPEI) and one for Pastel Partner (SPPI). Both these tools work in exactly the same way they have just been altered to suite each version of Pastel.
There is an administration section where you can synchronize any customer/vendor and Job details. New Supplier/Customers & changes to existing Suppliers/Customers in Sync will be uploaded into Pastel. New Jobs that are created in Sync are also uploaded into pastel (As “Projects” in pastel Evolution & “Cost Codes” in Pastel Partner).
This User Guide describes the steps to upload invoices and credit notes as well as GRV’s (Supplier invoices) and RTS
Steps are often complemented with the following information guides. Warnings, notes (additional information) and tips are indicated as follows:
- Tips
- Notes
- Warnings
Navigation
To start using the Pastel Integrator double click the Pastel Partner Integration icon situated on your desktop.
step by step guide: PASTEL INTEGRATION
1. Customer, Supplier and Job synchronization
CUSTOMER SYNCHRONIZATION
- SELECT Customers in the left menu. The list of customers will appear on the right hand side
- The unsynchronized customers are the ones that are either new customers in Sync or have been adjusted. Synchronized customers are ones that already exist in Pastel
- CLICK the synchronize icon at the top of this window to update all new/adjusted customers from Sync into Pastel.
SUPPLIER SYNCHRONIZATION
- SELECT Suppliers in the left menu. The list of suppliers will appear on the right hand side
- The unsynchronized suppliers are the ones that are either new suppliers in Sync or have been adjusted. Synchronized suppliers are ones that already exist in Pastel
- CLICK the synchronize icon at the top of this window to update all new/adjusted suppliers from Sync into Pastel.
JOB SYNCHRONIZATION
- SELECT Jobs in the left menu. The list of jobs will appear on the right hand side
- The unsynchronized jobs are the ones that are either new jobs in Sync or have been adjusted. Synchronized jobs are ones that already exist in Pastel
- CLICK the synchronize icon at the top of this window to update all new/adjusted suppliers from Sync into Pastel.
2. Upload invoices from Sync to Pastel
- In the Integration Tool, CLICK on Invoices (left in Modules Menu)
- The invoices appearing under the unsynchronized section means they have not yet been loaded into Pastel.
- The invoices appearing under the synchronized section are invoices that have already been loaded into Pastel
- CLICK ‘Synchronize” at the top of the window to send a batch file of all the unsynchronized invoices to Pastel
- All unsynchronized invoices are now uploaded in Pastel (Credit Sales, Debit Customer)
View your cost code / project in Pastel
- In Pastel go to view>>cost code>>cost code report Synchronize” at the top of the window to send a batch file of all the unsynchronized invoices to Pastel
- Set this report back by 12 months and run it for the end of the financial year (or one month later than the current month)
Print the tax invoice from Pastel
- View>>customer>>Print Document>>Tax Invoice
3. Upload credit notes from sync to Pastel
- In the Integration Tool, CLICK on Credit Notes (left in Modules Menu)
- The invoices appearing under the unsynchronized section means they have not yet been loaded into Pastel.
- The invoices appearing under the synchronized section are invoices that have already been loaded into Pastel
- CLICK ‘Synchronize” at the top of the window to send a batch file of all the unsynchronized credit notes to Pastel
- All unsynchronized invoices are now uploaded in Pastel (Credit Customer, Debit Sales)
Print the tax invoice from Pastel
- View>>Customer>>Print Document>>Credit Note
4. Uploading a supplier GRV (supplier invoice) into Pastel
- In the Integration Tool, CLICK on GRV (left in Modules Menu)
- All GRV’s done in the past will appear in the list
- To create a new GRV select ‘New GRV’
- This will open a new window where you have the option to do a GRV for a PO, PPO or manual entry
- PO – is for raw material (fabric or trims invoices)
- PPO – is for finished goods (completed item invoice)
- Manual entry – for something you don’t have an existing PO/PPO for (e.g. couriers) – if you select manual entry you will have to manually enter in the inv item (this is the account this transaction should be linked to within Pastel)
- In the New GRV window, CLICK the binoculars to search for the relevant PO / PPO
- This is pulled from the PO / PPO created in Sync
- DOUBLE CLICK on the PO to select it
- A PO / PPO screen appears
- COMPLETE GRV details:
| ENTER / AMEND the quantity of this purchase order
|
| Mark the GRV as captured or captured in full
|
- Click PROCESS to send transaction to Pastel (Debit Cost of Sales, Credit Supplier)
- The associated Pastel cost code or Project will also be allocated to the transaction
Print the job profitability report in Sync
- Reports>>Financial>>Job Profitability Report
5. Uploading RTS (return to supplier) into Pastel
- In the Integration Tool, CLICK on RTS (left in Modules Menu)
- All RTS done in the past will appear in the list
- To create a new RTS select ‘New RTS
- This will open a new window where you have the option to use the original GRV or you could do a manual entry
- In the New RTS window,
- SELECT ‘GRV Note’ as the line source to search for the GRV
- OR SELECT ‘Manual Entry’ as the line source to search for the Supplier
- DOUBLE CLICK on the GRV or Supplier to select
- COMPLETE RTS details:
| ENTER / AMEND the quantity of the units to be returned
|
| Mark the RTS as captured or captured in full
|
- Click PROCESS to send transaction to Pastel (Debit Supplier, Credit Cost of Sales)