Menu

Blog

Search

Category

AutoUpdated

Save time updating

Sage 50

Stock/Product Creation
Customer/Supplier Prices
Bill of Material
Project Creation
Location Bins

Sage 200

Simply extract, edit and import

Import from Excel

50 Trans

Nominal Journals
Quotes/Invoices/Orders
Remote Orders
Product/Stock Adjustments
Sales Receipts
Quick OrderPad

200 Trans

Transaction from Manual Input

Multiple Transactions from CSV file

Solve the Puzzle?

Sage 50

Help on every type of import
Demo Video of all functionality
Loads of Examples included
Online Training
We can help too…

Sage 200

Great Customer Satisfaction

Customer Comments

Full Trial with Demo Data
Low cost Subscription
Cancel anytime
From a £1 a day
Saving you hours

Simply extract, edit and import

Power of Excel

Sage 50

Quick Template Creation
Customise with:
    Formula
    Macros
    VBA

Sage 200

To reach your goals quickly

Sage 200 Bins

Sage 200 Warehouse & Bins

Create Sage 200 Bins
Stock Take Bins
Move Bin Stock

Fast, cost effective, easy…

Manufacturing

200 Manufact.

Create BOM Stock Easily
Create Bill of Materials
Labour, Machine, Tools

Complex tasks quicker...

50 BOM

Project Accounting

200 Projects

Create Project Structure
Update Budgets
Simple Project Entry

Make life easier...

50 Projects

PostTrans Blog

Why not sign up to recieve news, tips, ideas, training.  Sign up for bi-weekly newsletter.

Blog Search

Remote Purchase Order for Sage 50

Remote Restaurant Purchase Order

This sheet can be prepopulated with regular items to be ordered, and sent out to subsidiary Restaurant’s for data entry.

image

The manager of each subsidiary Restaurant can then fill in their requirements and e-mail back to head office. All items with zero quantity will be ignored (Pro Feature). Back at HQ a user simply opens the sheet, in Excel, and presses Import button on the PostTrans Toolbar to import PO’s.

The Unit Price column, which can be deleted if not needed, specifies the unit price. If not specified then the prices are read from Sage 50 Products Last Cost Discounted Price. But of course, would be finalised later in the Purchase Order Process.

The PO can be printed or automatically e-mailed to the supplier via Outlook (Pro Feature). This functionality is controlled in the ‘Print’ Tab of the Setup window.

To use the template, with Sage 50, install PostTrans. Download
Trial with Sage demo company. Purchase a month subscription for Live Sage Company. Price
Watch the On-line Training course on how to use and customise the templates.

Extracting Products

The product lines can be manually entered, with the aid of PostTrans In-Cell Searching, or copied from the “Products” sheet. The “Product” sheet allows product data to be extracted, using the PostTrans Extract button, from Sage 50. These can then be sorted, edited, or deleted, and pasted into the main order sheet, to enable fast remote data entry. The example data, which has been copied to the “Orders” sheet is shown in yellow.

see Sage 50 Product Extract/Import for more info

Categories: Sage Line 50, Transaction Data | Tags: | Return

Post a Comment

Blog Categories