Posts Tagged ‘Pastel’
Introduction
IT IS VERY IMPORTANT TO NOTE THAT NOVTEL DO NOT AT ALL CRITICISE PASTEL PARTNER’S WAY OF MANUFACTURING, OR SAY THERE IS SOMETHING WRONG WITH PASTEL PARTNER.
THE WAY PASTEL WORKS, WORKS FOR MANY COMPANIES; OUR CLIENTS SIMPLY HAVE DIFFERENT NEEDS TO PASTEL PARTNER’S OFFERINGS.
PASTEL TAKES OUR CLIENTS 75% TO WHERE THEY WANT TO BE AS FAR AS MANUFACTURING IS CONCERNED.
TOGETHER NOVTEL AND PASTEL PARTNER CREATES THE PERFECT MANUFACTURING SOLUTION FOR EVERYONE TO ENJOY.
The instructions received from our clients were as follows:
1. Design module for Pastel Partner that manufacture at last cost.
1.1 At the same time adjust selling prices of the manufactured goods as the mark-up % specified in
the BOM (Bill Of Materials) in Pastel Partner.
1.2 Base the selling price calculation of the manufactured item on the sum of the last cost of the BOM.
1.3 Allow the manufacturing process to automatic transfer manufactured stock items to the deferent
stores/branches in Pastel Partner.
1.4 Adjust the inventory quantities according the BOM’s defined quantities and store selection to
complete the manufacturing process with the new Novtel Manufacturing system.
2. Design system that automatically adjust shelf item’s selling prices based on last cost of the purchased item.
2.1 Pastel’s “Adjust Selling Prices” is not adequate because the adjustment requires manual Input form the user
after GRN’s (Goods Received Notes) are processed.
2.2 Each shelf item have 3 selling prices List A, B and C; each inventory category have different pre-set
mark-up margins.
2.3 The mark-up margin for each inventory item needs to be recorded on the Pastel inventory master file showing the % mark-up for each price list.
2.4 For the mark-up margins the 3 Inventory Numeric user defined fields in Pastel are used to store the information.
2.5 All purchased goods are received in a store we call this receiving store; the Pastel GRN’s are done in this store as deliveries are received from
suppliers.
2.6 All manufactured and shelf items are transferred form the receiving to the various stores we have.
2.7 Design a store transfer module that will adjust the selling price of each shelf item based on the
mark-ups as described in note 2.2, 2.3 and 2.4 above as stock transfer are done.
3. Referring to 2.2, 2.3 and 2.4 above design a system that will automatically populate the Inventory
mark-up % to each of the 3 Inventory item’s Numeric user defined fields allow this automatic %
mark-up adjustment to be made per inventory category.
4. Design System to adjust stock on hand per inventory item to “0″ quantity on hand with the click
of one button; allow this adjust stock to “0″adjustment to be made per inventory category. This feature is to help with the take
on of new stock balances at last cost.
Manufacture at last cost
Pastel can only manufacture at average cost.

For the Novtel Manufacturing system to work the Bill of Materials item have to exist as an Inventory item in Pastel
the Lock BOM to this item and Update Selling Price tick boxes must be ticked as shown in the example below.

Each component of the Bill of Materials do have a average cost and last cost. Pastel’s calculation of
average cost calculated as follows:
Total amount paid for the inventory item divided by the quantity purchased.
There is no periods or dates linked the calculation of Pastel Average Cost it is simply average of all transactions on the master file
for that specific inventory item over the period purchases were done by the system.
The Edit Bills of Materials screen of Pastel can show what the selling prices should be at last cost in the example below.

The only problem is that when the actual manufacturing process is done in Pastel the system will manufacture at average cost only.
Issues resolved and new features:
Grid:
Added Account Balance (Pastel or Local if not integrated) to the tool tip that comes up when you point to a departed reservation on the grid.
Added the User Defined Fields to the Tooltip on right-click on grid (Room number) and selecting ‘Detailed Description’
Credit Note:
Added the option to do Credit Notes towards In-House Group reservations.
Added functionality to select a Multi-store location per line to enable passing correct Credit Notes on Invoices utilizing the recently added additional Multi-store for Restaurant/Bar staff.
Charges:
Added ‘Recipe Item’ and ‘BOM Code’ to accommodate “Manufacturing”
Pastel Interface:
Added the option to enable BOM (Manufacturing) or disable.
Note: Enabling this option is at the moment only functional for testing and not available for commercial use.
Reservation Payment:
Limit the number of character on the Credit Card number to Max 20.
Short/Over Journal processing:
Incorporate the following changes to accommodate all users allowed to do cash based transaction and cash based credit note transactions.
@ Interface Pastel:
Short/Over Account must be entered on POS tab if ‘Posting of Shortage/Over Journal by Supervisor Shift Cashup’ is checked on Setup Company – POS tab. All Short/Over will be posted towards the Short/Over Account if Gratuity GL Account as described below is not present.
@ Setup Users/Passwords:
By entering a ‘Gratuity GL Account’ on the Restaurant tab (only available for Restaurant/Bar Staff) this account will be used for processing the specific Staff member’s Short/Over.
Setup Users/Passwords:
Custom user permission
Merge user permission on Setup Company and 3rd Party Interface to allow or disallow a ‘Custom’ user accessing Setup Company and Interface.
Reports:
Utilization report:
Remove check box “Show Disposed Rooms”
List Availability Report:
Fix ‘From’ and ‘To’ time picker
Rental Statistics Report:
Remove this report from the menu as it is not used
Current Activity Report
Fix error incorrectly displaying the RA number instead of the Reservation number on Departure. This error was due to previously changing the report not to show the RA number.
Restaurant & Diet
Change to populate values from the ‘Adults’ and ‘Children’ entry on Details Reservation General TAB. Report sort order changed to place ‘Adults’ first and then the ‘Children’.
Usage Report:
Change Category to Guest Tariff
Income Projection:
Remove the Paid status from selection.
Deposit Transaction listing:
Change to accommodate the changes made in handling deposits.
Reservation Details:
Deposit Refund:
Fix Amount Refunded displaying incorrectly when Deposit refunded in total.
Made some changes to dynamically display Deposit Refund and Forfeit on the Financial tab.
Added an option not to cancel the individual reservation when refunding the deposit.
Added the option to refund a deposit in part without cancelling the Reservation.
Added a checkbox ‘Apply Charges to Reservation’ on Financial tab to accommodate Group members responsible for own expenses.
Restaurant:
Made the necessary changes to incorporate Multi-store on the Extra/Component Item level.
Group Additional Cost Allocation Manager:
Change to dynamically update Service Charges when opening the Group Additional Cost Manager.
Fix an error occurring on Service Charges when moving line transactions from Group Reservation to Group and back.
Added the following Captions to accommodate ‘Deposit Refund’ and ‘Deposit Forfeiture’ on ‘Group Reservations’ and ‘Group’:
- Deposit Refund Total
- Deposit Forfeit Total
Added ‘Room Rental’ Caption to the Group Reservations to accommodate the new option to apply ‘Room Rental’ on a Group Reservation towards the individual Reservation.
Issues resolved and new features:
Group:
Fix when changing ‘Duration Charged’ to NOT dynamically update Reservation end date and Grid after saving Reservation.
This is used for a longer stay shown on the grid than at ‘Duration Charged’. Example – Guest stays 14 days and gets 2 days free. Show on grid 14 days but only 12 days at ‘Duration Charged’.
Reports:
Restaurant & Diet
Fix to show only selected day’s records.
User/Password:
Fixed an error encountered when editing a Bar/Restaurant User with Gratuity code not entered.
Fixed an error encountered when not populating and using Multi-store code 2.
Fix to only make Setup – Users/Passwords – Restaurant TAB ‘Gratuity GL Account’ required…
if Setup – Company – POS TAB ‘Posting of Shortages/Surplus by Supervisor Shift Cashup’ is checked
and Setup – Interface – Pastel POS TAB ‘Short/Over Account’ is left blank.
Issues resolved and new features:
Group:
Fix when adding a Reservation from Group Details – Reservation Tab to dynamically update Reservation Details with the correct Price per Room or Price per Person.
POS Retail:
Fix Receipt captions to display only relevant information for the different payment types.
Add option to make In-House Group transactions
Group Additional Cost Allocation Manager:
Fix not to show and calculate individual deposits.
Reservation Details:
Quick View:
Fix not to show previous Applied Deposit when creating a new reservation.
Fix changing ‘Duration Charged’ to dynamically update Reservation end date and Grid after saving Reservation.
Reservation Record Create Date:
Change the program to utilize the Windows regional settings in the date and time format.
Deposits:
Remove selection by Contract Number. Not used in Hospitality.
Reports:
Deposits
Remove Out of Date Contract Deposits report from menu.
Restaurant & Diet Report:
Fix to show only in house guests with an entry in their Restaurant & Diet record.
Money Count:
Added a 0.25 currency denomination for international use.
?
Issues resolved and new features:
Restaurant/Bar:
Display size:
Resize of ‘Top’ buttons for 800×600 and 1024×768 with the incorporation of the ‘Bar Sales’ button.
Receipt and Bill:
Option added at Setup Company – POS – Print Bill/Receipt combination instead of Receipt
Un-checked prints Receipt
Checked prints Bill/Receipt combination
Account Payments:
Fix ‘Account Payments’ debit\credit balance which was showing in reverse. (v5.1.0.9)
Reports
Daily Activity Report:
Remove RA Number
Activity Report:
Remove RA Number
Multi-Store:
Fix the Cash consolidated Restaurant/Bar invoice to correctly handle Multi-Store transactions.
Multi-store management by Charges – ‘Bar Item’ and ‘Menu Item’:
Checking both ‘Bar Item’ and ‘Menu Item’ at Charges will result in the following:
When a Bar Staff member selects this item the multi-store will default to the Bar Staff member’s Bar multi-store.
When a Restaurant Staff member selects this item the multi-store will default to the Restaurant Staff member’s Restaurant multi-store.
POS Retail:
Fixed not to create a Service Charge line to Pastel when Service Charge is NULL.
Money Count:
Report:
Fixed Money count report to show ‘Shortage’ as negative.
Short/Over journal automation:
Setup Company – POS – General
‘Posting of Short/Over by Supervisor Cashup’
Un-checked:
Do Journal manually as back office transaction
Checked:
When using this option it is important to note that Money Count procedures must be followed as the Short/Over on the Money Count determine the amount used for the Journal creation. Closing of a shift by the Supervisor will result in not passing a Short/Over Journal to Pastel. This can be corrected by doing a manual back office Journal in Pastel.
2 Options available:
Option 1
Entering an account at Setup Interfaces – Pastel – POS Tab- Short/Over Account as well as an Entry Type for Short/Over.
This account will be debited and the Daily Takings Control Account will be credited in the event of a Shortage.
This account will be credited and the Daily Takings Control Account will be debited in the event of a Surplus.
Option 2
Leaving the account blank at Pastel Interface – POS – Short/Over Account will result in using the Gratuity account at Setup – Users/Passwords – Restaurant Tab.
This Gratuity account will be debited and the Daily Takings Control Account will be credited in the event of a Shortage.
This Gratuity account will be credited and the Daily Takings Control Account will be debited in the event of a Surplus.
Grid:
Status – In House
Allow setting Status to In-House for future bookings can now be managed:
Setup Company – General – Allow changing Status to In-House for Future bookings
Checked
Changing Status of future bookings to In-House allowed.
Unchecked
Changing Status of future bookings to In-House disallowed.
Novtel Property Management is a leading, feature rich, flexible and extremely easy to use software solution for everyone who are involved with managing properties on a regular basis. The current day to day users of our property management solution can be listed as follows:
• Residential Property owners.
• Commercial Property owners.
• Municipalities with rental properties.
• Social housing companies.
• Rental management Agents.
• Golf estates with rental pool.
• Body corporate.
• Body corporate management agents.
• Fractional ownership management agents.
• Estate agents with rental divisions.
• Self catering Holiday resorts
• Caravan Parks
Novtel property management systems are able to manage long-term monthly rentals as well as short term holiday day to day rentals.
The real power of Novtel Property management is the fact that we seamlessly integrate with Pastel Partner.
Hospitality Version 5.1.0.2
Issues resolved and new features:
Setup Company POS Frame Restaurant/Bar:
Reprint Bill with Supervisor permission.
Checked – Restaurant/Bar Bill can only be printed once. If a reprint is needed the Supervisor must give permission.
Un-Checked – Can be reprinted without Supervisor permission.
Bar/Restaurant:
Reprint Bill with Supervisor permission according to the settings above.
Restaurant/Bar:
Created a screen capture report of the money count in addition to the report available at the money count.
Front desk/Shop:
Created a screen capture report of the money count in addition to the report available at the money count.
Novtel Hospitality Forms Designer:
Fix the forms designer to work with Novtel Hospitality. This is a Forms Designer in addition to the Novtel Reservation Forms Designer. At the moment you will have to create the desktop icon manually from c:\Program Files\Novtel Hospitality\Novtel Forms Designer.exe. This will be automated with the next CDH2 build.
Forms are now filed in C:\Program Files\Novtel Hospitality\Forms\
Remember to copy previously created forms for Hospitality from c:\Program Files\Novtel Reservations\Forms to c:\Program Files\Novtel Hospitality\Forms in order to use them. New forms will be stored by default in c:\Program Files\Novtel Hospitality\Forms but can be stored in another location as well.
Relations Ver. 4.4.0.5 released on 2009/09/23
Added an option to view or remove an attachment before the email is saved.
JFOE-3C81E4F1F
Fixed a bug related to creating a Template. Only part of the file was displayed after saving the file. Only a partial file were shown when using a “ in the text.
Added an information message when sending SMS to all selected if Available SMS Balance is less than Records selected.
Fixed a potential bug at Ad New Customer / Supplier when clicking Accept without entering a Code. An empty record was created and program stopped due to a critical error.
Added a search function to select by ID Number
JFOE-2E953E966
Removed option to select Attachment on Send SMS and SMS All
Added an option at Report Customer Correspondence and Supplier Correspondence to search on a specific User in addition to only searching on all users.
This release replaces all previous releases and can be downloaded on following link below:
Novtel Reservations version 4.2.0.0 released on 2010/01/19
Novtel Reservations include the following Products:
* Vehicle Hire
* Property Management
* Contract Management
The program was adjusted to manage ‘customer’ —- ‘monthly payment date’ better.
The ‘Contract Escalations Report’ is now available in Property Management.
The Contracts Report has been adjusted to include the “Payment Day” and also to sort the report according to the “Payment Day”.
Corrected an ‘Item can not be found’ error that sometimes displayed on the Deposit Liability report.
The “Supplier Monthly Statement” for Property Management was improved.
This release replaces all previous releases and can be downloaded on following link below:
Novtel was established in 1996 since then have gradually grown into global leading software house.
We are a focused front end application developer; all our products are related to the rental, hire and leasing industries.
Novtel interface to various accounting and other software packages such as Pastel Partner, Quick Books, MYOB and Microsoft.
This software automates most of the bookkeeping functions of the businesses where it is successfully implemented; it is extremely powerful, feature rich and easy to use.
Our wide experience in computerised accounting and operational software systems means that we can provide a service, which covers system selection, set up, development and training.