Sales

191

Solutions

379

Contributors

Sales is the act of selling something; the exchange of goods, services, or property for money. Use this topic to talk about sales cycles & funnels and sales strategy. Please do not use this topic for Marketing.

Share tech news, updates, or what's on your mind.

Sign up to Post

For the point of sales app I want to use the input box because for Tax purpose because the tax rate keep on changing year in year out , what I want to do is to hard code the txttax control to be only receiving percentages not absolute values , how do I do it? For example I want to be seeing rates like 10% , 16% etc whatever is applicable not values like 10,16 etc.

Private Sub ProductID_AfterUpdate()
Dim s As String
s = InputBox("Tax Value required", "Internal Audit Manager ", "Tax Percentange")
Me.txtTax = s
End Sub

Regards

Chris
0
Exploring SharePoint 2016
LVL 13
Exploring SharePoint 2016

Explore SharePoint 2016, the web-based, collaborative platform that integrates with Microsoft Office to provide intranets, secure document management, and collaboration so you can develop your online and offline capabilities.

Finally my point of sales is complete but with one more help required here:

(1) When a product code is selected , automatically the selling price, quantity sold , taxes and the line total are completed , it also allows to alter the quantity sold just in case the customer has bought more than 1 quantity.

Assistance required

Since the whole line is completed automatically how can I make the cursor move to a new line (add new line) without manually again entering through the whole line?


Regards

Chris
0
We are now required to be scanning the bar codes for the supermarket stock using the point of sales ms access software when selling:

(1) all the stock are stored in the inventory table using the bar codes in place of stock codes
(2) Some stocks can be manufactured within the company some are ordered from outside if there are some pick periods especially monthends

Assistance required:

(1) To avoid wrong bar codes capturing in the software, is it possible the Ms Access 2016 built software can allow the bar codes scanning as a method of imputing the stock /Bar code in the system? There is a text control in a form for imputing bar code which require imputing the bar code manually

(2) Since  the cash sale form has a similar text control but in a combobox control form is it possible to be scanning the same bar codes here also, remember the bar codes are stored in the product table  hence the reason for the combobox in the cash sale form to easy lookup?

(3) Since the prices are linked to the product codes/ Bar codes such that once the product code/ bar code is selected the price also come automatically, now the question in the text control where we are required to capture the stock sold, is it possible to have the control show a default one (1) quantity sold automatically? or if the customer is buying more than one then the quantity can be over written manually?

Regard

Chris
0
Hi

Kindly see how you can assist in another cumulative column under commission, I have done it for one column called sales  is now showing cumulative with two criteria. How do I add another column called commission as cumulative as well?

SELECT T1.IDLine, T1.Monthend, T1.ProductCode, T1.Qty, T1.Commision, (SELECT Sum(tblLinedetails.QTY) As Total
FROM tblLinedetails
WHERE  (tblLinedetails.Monthend <= T1.Monthend) AND tblLinedetails.ProductCode = T1.ProductCode) AS Total
FROM tblLinedetails AS T1;

Open in new window


Well Dale Fye advised clearly the problem of slowness with ELookups & Dsum , I now totally agree with him that the way forward is to settle on Subqueries.
Regards

Chris
0
I am concerned; I close to buy a Power 9 (IBM SYSTEM) to replace our AS400 (ISERIES).

This sales is through a business partner. We only need the equipment with the last OS and releases and also the last PTF for the that OS, we will transfer the information from the AS400 TO POWER 9.

My business partner says

Agnes,

This system will ship with the IBMi OS installed with the latest RS (re-spin this is a re-spin of the OS with PTF’s) level that is available at order time. This is not the latest PTF levels but it does have PTF’s already installed on the OS. The system will also ship with the latest RS level of the Program Products.  If SFNH(ME) wants to install the latest level PTF’s this also would be SFNH's(ME) responsibility, but the OS will come with some already installed.

Is this true? the equipment doesn't comes with the last PTF? so I have to pay to somebody else to apply the rest PTF's? and what about the OS release now is 7.3 have to come with that right?

Please if somebody knows about this could you please guide?

Thank you for your help
0
Help me to refine the code below , what is required here is that an item must be selected only ONCE from the combo account ANY second selection must be reject . The reasons for that is that the people who will be capturing a sales invoice should not be involved in double entry.

The combo Account ID is populated with only four accounts , that is revenue, discounts, VAT and Excise duty linked as ( 69,73,76 and 92 as Primary Keys), since auto selection appear to be not working ( What I mean if the invoice number is generated then the four accounts in the sub form must be populated 69,73,76 and 92) the only way is to use manual selection  such that we need to prevent several selection of one item in the combo Account ID:

Private Sub AccountID_AfterUpdate()
Dim Cancel As Integer
If (Me.AccountID = "69") Then
Beep
MsgBox "Duplicate are not allowed", vbOKOnly + vbExclamation, "Internal Audit Manager"
Cancel = True
Exit Sub
ElseIf (Me.AccountID = "73") Then
Beep
MsgBox "Duplicate are not allowed", vbOKOnly + vbExclamation, "Internal Audit Manager"
Cancel = True
Exit Sub
ElseIf (Me.AccountID = "75") Then
Beep
MsgBox "Duplicate are not allowed", vbOKOnly + vbExclamation, "Internal Audit Manager"
Cancel = True
Exit Sub
ElseIf (Me.AccountID = "76") Then
Beep
MsgBox "Duplicate are not allowed", vbOKOnly + vbExclamation, "Internal Audit Manager"
Cancel = True
Exit Sub
ElseIf (Me.AccountID = "92") Then
Beep
MsgBox "Duplicate are not allowed", vbOKOnly + …
0
Hi

Background

The management want special general ledger accounts to be attached to the sales invoice automatically so that no manual selection of GL accounts can be allowed to account for the following:

(1) Sales
(2) VAT
(3) Discounts
(4) Excise Duty

Now on the main form I have created un bound controls to summaries the content of ( Sales , VAT, Discounts & Excise Duty) as you can see above , and below are the controls created on the main form to do the required summaries:

(1) txtInvoicesSales
(2) txtInvoicesVat
(3) txtSalesDuties
(4) txtsalesInviiceDiscounts

The mentioned controls above does a good job as you can see from the picture below.

Now I want help to assign both general ledger codes and the value content in the controls above , I have tried the code below it does not work , any help here will be highly appreciated

Private Sub Form_BeforeInsert(Cancel As Integer)
If (Me.Parent!txtInvoiceSales <> "") Then
Me.AccountID = 120 - 15 - 6660 And (Me.Credit = Me.Parent!txtInvoiceSales)
ElseIf (Me.Parent!txtsalesinvoiceDiscounts <> "") Then
Me.AccountID = 110 - 16 - 1004 And (Me.Debit = Me.Parent!txtsalesinvoiceDiscounts)
End If
End Sub

How do I do it?

Sales-accounting.png

Regards

Chris
0
I have the following two queries below. What I am attempting to do is compare my results from current production to archived data from the week prior. My goal is to compare sales by season OTSWIP and SUM of the std_cost. However when I attempt to join the two queries together my results get exaggerated. I'm not certain what I am doing wrong?

Production Query is as follows. I Receive 23 rows. Results are attached.

SELECT  cs.season ,
        cs.season_name ,
	    SUM(CONVERT(INT, cs.OTSWIP)) AS OTSWIP ,
	    SUM(cs.Ext_std_cost) AS Ext_std_cost
FROM    ( SELECT    c.DIVISION ,
                    c.STYLE ,
                    c.COLOR_CODE ,
                    c.LBL_CODE ,
                    c.std_cost ,
                    c.season ,
                    CASE WHEN c.season IN ( '20121', '20122', '20123', '20124',
                                            '20125', '20131', '20132', '20133',
                                            '20134', '20135', '20141', '20142',
                                            '20143', '20144', '20145', '20151',
                                            '20152', '20153', '20154', '20155',
                                            '20161', '20162', '20163', '20164',
                                            '20165', '20171', '20172', '20173',
                                            '20174', '20175', '20181', '20182',
                                            '20183', '20184', '20185', '20191',
                       

Open in new window

0
Hi people There!

I having problems assigning a bound control within a sub form called sfrmCostofSales subform] see the photo below . I want a control called stdcost to be updated by un bound control called txtperformance which carries special calculation for cost of sales , I tried the VBA code below , but nothing is working:

Private Sub Form_BeforeInsert(Cancel As Integer)
Me.StdCost = Forms![frmCustomerInvoice]![sfrmCostofSales subform].Form![txtPerformance]
End Sub

The parent form is called frmCustomerInvoice , could it be I'm using a wrong event.

Instead of entering calculation of cost of sales per unit manually I want this control called stdCost which is bound to the table to be update by this unbound control within the datasheete subform called sfrmCostofSales subform] which calculate the correct cost of sales

Kindly help!

SubFormCosting.png

Regards

Chris
0
Hello,

I have a list of part numbers that I need to search through and compare the first two characters of the part number to another cell.  Then I have to use a multiplier in another cell in order to give a final sales price.  In the attached image I have three possible markups and a default markup.  So for Mark up 1 I want to search through column E for and part #s beginning with "45" for all those part #s I want to multiply the Costs X 1.5 and place the value in the Sale Price column G.  For Mark up 2  I want to search through column E for and part #s beginning with "S7" and for all those part #s I want to multiply the Costs X 2 and place the value in the Sale Price column G.  There is no field for Mark up 3 (for future use).  All other part numbers use a default mark up of 1.75.


I tried using VLOOKUP, but it's too limited.  I have tried to use INDEX, but can't get that to work either.


I'd appreciate any suggestions.

Thanks,

Larry
excel.JPG
1
JavaScript Best Practices
LVL 13
JavaScript Best Practices

Save hours in development time and avoid common mistakes by learning the best practices to use for JavaScript.

Need Key Word search tools

I need free tools which let me search for words that are used very often. This is for SEO, since I want a high hit rate.

What can you suggest? And what other advice can you offer on SEO? I am starting with my YouTube channel...and will use these key words in the meta-data.

Thanks
0
Hi

I have a point of sales module within the main accounting application , now when printing it is accepting only to print on A4 Paper which is a waste of paper, I have no problem when printing ledgers but a pos receipt must come on a thermal receipt printer and paper size is about 80mm. While discusing about this yesterday someone passed the below code to me to study it and see may be it can sort out the problem. To be honest I did not understand it how it works and where to put either in the report module or a function,kindly can someone help me on this, some may have come up with this before.

(1) It appears like it first opens the report in design mode and that is where I do not understand it!

Sub sSwitchPaperSizeToLegal(rptName As String)
'The purpose of this sub is to set the page size
'for a report to legal
Const SUB_NAME$ = "sSwitchPaperSizeToLegal"
Dim DevString As str_DEVMODE
Dim DM As type_DEVMODE
Dim strDevModeExtra As String
Dim rpt As Report

'Open report in design view.
DoCmd.OpenReport rptName, acDesign 'Open report in Design view.
Set rpt = Reports(rptName)
If Not IsNull(rpt.PrtDevMode) Then
strDevModeExtra = rpt.PrtDevMode ' Get current DEVMODE structure.
DevString.RGB = strDevModeExtra
LSet DM = DevString
DM.lngFields = DM.lngFields Or DM.intPaperSize Or DM.intPaperLength Or DM.intPaperWidth
'DM.intPaperSize = 5 'legal
DM.intPaperWidth = 800 '80mm
DM.intPaperLength = 32760 '3276mm
LSet DevString = DM 'Update property.
0
Hi Experts out there!

I want to populate the three controls on the point of sales form automatically immediately the productID is scanned;below are the required controls:
(1) Product name
(2) QtySold
(2) Selling price

The above controls (Product Name & Selling Price) are combos,While QtySold is a number control but I want it to be assigned a number called 1 (QtySold = 1 but can be editted in case a customer is buying more than one item) here my understand is that a combo box is simply a small query from the underlying table/tables , I still think they can still be looped on the basis of the change on the productID. The business logic here is that there shall be no manual intervention here.

ProductID combo :
SELECT tblProducts.ProductID, tblProducts.ProductName
FROM tblProducts;

Slling Price Combo:
SELECT tblProducts.ProductID, tblPricing.Prices, tblProducts.ProductName, tblPricing.Changedate, tblPricing.Status
FROM tblProducts INNER JOIN tblPricing ON tblProducts.ProductID = tblPricing.ProductID
WHERE (((tblPricing.Status) Is Null Or (tblPricing.Status)<>"2"));

Kindly see how can help here

RegardsPos-receipts.png
Chris
0
Hi

I know we have a good number of experts here and very experienced, now I need guidance on the VBA function that can retrieve the data from Json format like below:
{
"code": "500",
"Naration": "OK",
"declared-info": {
"Receipt-code": "3333333",
"Receipt-number": "111111",
"Customer-ID": "1025360",
"Customer-vat ": "78963102",
{

I hope you can see the parameters above, the VBA function when run need to grab the data from those parameters from the point of sales machine (POS). The accomplishment here is to ensure that the receipts that are created from the POS machines are not recaptured into Ms Access Application , instead they must be automated to avoid errors, this is the requirement by our client of which we do agree the concept.

Regards

Chris
0
Combo propertiesHi

(1) I'm almost done with the point of sales , now I want some help on the visibility of the form combo content , when I select the price in the combo it does not show on the form but it is applied to the invoice and stored very well on the invoice table , there a way to force it show also on the form . Just look at the picture below.

(2) I want also to be printing the invoice after saving on the save form below, do I have to create a second query for the current form to supply the parameters to the underlying query so that  the report invoice go to the printer immediately  after pressing print button?

Below is the actual form:

Pos form

Also combo properties
0
I need some help with a CASE statement.

I am looking at sales order lines and linking out to a reference table. I want the case to output 'MY STRING' If at least 1 line on the order has the value 'WILLIAMS'. Nothing output if no lines contain this value.

So far I wrote a query to return the reference, then added a count where the reference equals Williams.

Select count(ITEM) from (
    select D5.ORD_NUM, D5.ORD_LEV1 ITEM, D3.ALT_INVT_REP_CODE BRAND
    from E_ORD_D5 D5
    LEFT JOIN M_ITEM_D3 D3 on D3.COMP_CODE = D5.COMP_CODE and D3.CUST_CODE = D5.CUST_CODE and D3.ITEM_CODE = D5.ORD_LEV1
    where D5.comp_code = 'W1' and D5.ord_num = 935373 
    )
WHERE BRAND = 'WILLIAMS'

Open in new window


Not sure how to make this part of a CASE. (of if CASE is even the best approach)
0
Hello :-)

I have an excel spreadsheet where there is a product code and the sales amount of that product per day. I need to take the average sales per day range for a given product. How many sales for product 01 between 10/11 and 02/12 for example.

Some idea?

The spreadsheet:
med.PNG
0
(1) I'm required to deliver the access application system in a supermaket envirnoment, now the number of cashiers will be 20 (Users) accessing the same sales accounting or tables. My application is split into backend & front end of which per user will have their own front end linked to the backend on the server.My fear here is the locking system even if all my forms show the record locks property  - No Locks, any idea how go about this?

(2) I have also experienced some issues of power failure in some clients work place, now because of the same you find in the FE folder sometime their is an extra file generated after power failure any idea how to sort out this? Though my current advice to the clients is to invest in UPSs

Regards

Chris
0
Example.xlsxExample.xlsxI have a spreadsheet, attached, of my prior year monthly sales, and my current YTD monthly sales.

How do I write a formula (not an array or VBS please) to compare YTD totals through this month last year, compared to this month this year?

Thank you.
0
Become a CompTIA Certified Healthcare IT Tech
LVL 13
Become a CompTIA Certified Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

I need traffic to my website. I have started with Social Media, Submitting my sites to Search Engines.

Several years ago, I studied SEO but, I have found that things have changed so much as it pertains to traffic such as Meta Tag's submissions and PPC.

I am looking to building up my traffic up to my E-commerce Websites / Aliexpress Affiliate websites.

Can you help me to build my traffic to my websites and to build my SEO?  My sites are very new in the development stages. If possible I would like free or low costing options.

Thanks in advance Experts.
0
I have a website that I designed with the Aliplugin.  This is it: http://essmen.com/.  My website visits are about 400 visits per day with any advertising other than links on Facebook, Twitter, and Google Plus.  I have two problems. One is the traffic and the other is that fact that no one is buying any of the affiliate products.  I have close to 19000 products on the website and can add more. I was advised by the Alipartnership to add as much product to increase my chances of indexing quickly.  I am a complete newbie and want to stop spinning my wheels on these issues. Can I get a little help on getting possible free traffic or very cheap traffic? And, I want to know how I can possibly get some one to buy something on my website to start making affiliate income?  I have had the website up going on two months. I do not want to just jump ship now based on the advise of the Aliplugin people. i'm just sayin'
0
How to calculate Last 2 months average sales in sql server (excluding the current month)
0
I have been working as a consultant for a number of years,    I have a diverse and pretty extensive background, I basically do server\desktop\network\firewall\VPN\Exchange hosting\DR\Business continuity down to desktop preventive maintenance, builds etc.. Basically whatever is needed.

One of my larger clients has concerne if I were to die where that leave them.  From day one due to my background of managing IT, and staff for companies with multiple location and being a senior IT person prior to consulting. I always put in place what I could to minimize exposure.  I do the same with the current client base.  Admin passwords are on file, all prod servers always covered by contracts with an SLA of on site in 4 hours etc.

This is a difficult one to answer.  They are under the false impression they would be safer with a larger consulting company. They will never get this level of responsiveness/expertise/service/or price.   I would love to grow the business and bring on someone else, or possibly acquire another consulting business, do I try to find a commissioned sales rep?  Or even take over accounts of a small consulting business in the area where the owner was close to retiring, but for the life of me, I am not sure how to find consulting businesses that might be for sale, or someone in a similar situation that I can trust, and would not go after our clients etc.
Surely there are other consultants on this site that are in similar situations.    If you think about it, we…
0
Doing a pst migration in tandem with an email migration into O365. We are using native tools so far, but with the nature of pst imports into O365, the manual process of setting up batches has been a bear to deal with. All the users are storing psts on their personal network share, so not a centralized location. Many users have multiple psts of varying sizes.  They are willing to consider a 3rd party tool to help, but there are so many out there. I haven't used any yet. Can anyone suggest what tools they have used, what they liked and disliked? Trying to make an informed decision without all the sales hype. Thanks!
0
I'm planning to go for Amazon FBA business & was recommended to get
Helium 10 to do analysis of sales in Amazon.

Q1:
Someone told me it's almost US$200/month subscription or is it
US$200 once off?

Q2:
While waiting for promo (heard sometimes there's half price), anyone
can suggest a similar freewares (that once I key in an ASIN ie Amazon
Stock I...  Number), it will list competitive products with their $ sales
turnover, profit margins (for each product), sales in terms of qty
0

Sales

191

Solutions

379

Contributors

Sales is the act of selling something; the exchange of goods, services, or property for money. Use this topic to talk about sales cycles & funnels and sales strategy. Please do not use this topic for Marketing.